package com.itzz.spring_zhoneHeng.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itzz.spring_zhoneHeng.pojo.Member;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface MemberDao extends BaseMapper<Member> {

    //根据id回显会员信息
    Member queryById(Integer uid);

    //修改用户姓名和会员数据
    int edit(Member member);

    //根据uid删除u_mb表数据
    @Delete("delete from u_mb where uid = #{uid}")
    int deleteU_MB(Integer uid);

    //添加u_mb表数据  根据uid添加u_mb表数据   (2)绑定用户和会员表
    int addU_MB(Integer mbid,Integer uid);
}
